﻿CREATE TABLE [dbo].[Employee_Allowance] (
    [id]             INT              IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [EAId]           UNIQUEIDENTIFIER NULL,
    [CategoryId]     INT              CONSTRAINT [DF_Employee_Allowance_CategoryId] DEFAULT ((0)) NULL,
    [AName]          VARCHAR (50)     NULL,
    [Amount]         NUMERIC (18, 2)  NULL,
    [Memo]           VARCHAR (MAX)    NULL,
    [UpTime]         DATETIME         CONSTRAINT [DF_Employee_Allowance_UpTime] DEFAULT (getdate()) NULL,
    [PostCategoryId] INT              CONSTRAINT [DF_Employee_Allowance_PostCategoryId] DEFAULT ((0)) NULL,
    [PostId]         INT              CONSTRAINT [DF_Employee_Allowance_PostId] DEFAULT ((0)) NULL,
    [Pid]            INT              CONSTRAINT [DF_Employee_Allowance_Pid] DEFAULT ((0)) NULL,
    [Cid]            INT              CONSTRAINT [DF_Employee_Allowance_Cid] DEFAULT ((0)) NULL,
    CONSTRAINT [PK_Employee_Allowance] PRIMARY KEY CLUSTERED ([id] ASC)
);

